How to suppress / hide the query output in bq command line - Bigquery

While using the bq CLI to execute queries, bq query displays the query output every time. In order to suppress/hide output from bq query command,

Use the -n=0 option to bq query. Here is an example with and without this option:

\n\n
$ bq query --use_legacy_sql=false "SELECT x FROM UNNEST([1, 2, 3]) AS x;"\nWaiting on <job id> ... (0s) Current status: DONE   \n+---+\n| x |\n+---+\n| 1 |\n| 2 |\n| 3 |\n+---+

With suppressed log: 

$ bq query -n=0 --use_legacy_sql=false "SELECT x FROM UNNEST([1, 2, 3]) AS x;"\nWaiting on <job id> ... (0s) Current status: DONE\n

Ryan-Dallas

posted on

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds